<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<title>CellReference (POI API Documentation)</title>
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
</head>
<body>
<script type="text/javascript"><!--
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="CellReference (POI API Documentation)";
    }
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
<!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/CellReference.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/util/CellRangeAddressList.html" title="class in org.apache.poi.hssf.util"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/hssf/util/HSSFCellUtil.html" title="class in org.apache.poi.hssf.util"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/util/CellReference.html" target="_top">FRAMES</a></li>
<li><a href="CellReference.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li><a href="#nested_classes_inherited_from_class_org.apache.poi.ss.util.CellReference">NESTED</a>&nbsp;|&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#methods_inherited_from_class_org.apache.poi.ss.util.CellReference">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li>METHOD</li>
</ul>
</div>
<a name="skip-navbar_top">
<!--   -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<p class="subTitle">org.apache.poi.hssf.util</p>
<h2 title="Class CellReference" class="title">Class CellReference</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li><a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">org.apache.poi.ss.util.CellReference</a></li>
<li>
<ul class="inheritance">
<li>org.apache.poi.hssf.util.CellReference</li>
</ul>
</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<hr>
<br>
<pre>public final class <strong>CellReference</strong>
extends <a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a></pre>
<div class="block">Common conversion functions between Excel style A1, C27 style
  cell references, and POI usermodel style row=0, column=0
  style references.</div>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- ======== NESTED CLASS SUMMARY ======== -->
<ul class="blockList">
<li class="blockList"><a name="nested_class_summary">
<!--   -->
</a>
<h3>Nested Class Summary</h3>
<ul class="blockList">
<li class="blockList"><a name="nested_classes_inherited_from_class_org.apache.poi.ss.util.CellReference">
<!--   -->
</a>
<h3>Nested classes/interfaces inherited from class&nbsp;org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a></h3>
<code><a href="../../../../../org/apache/poi/ss/util/CellReference.NameType.html" title="enum in org.apache.poi.ss.util">CellReference.NameType</a></code></li>
</ul>
</li>
</ul>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_summary">
<!--   -->
</a>
<h3>Constructor Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colOne" scope="col">Constructor and Description</th>
</tr>
<tr class="altColor">
<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/hssf/util/CellReference.html#CellReference(int, int)">CellReference</a></strong>(int&nbsp;pRow,
             int&nbsp;pCol)</code>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/hssf/util/CellReference.html#CellReference(int, int, boolean, boolean)">CellReference</a></strong>(int&nbsp;pRow,
             int&nbsp;pCol,
             boolean&nbsp;pAbsRow,
             boolean&nbsp;pAbsCol)</code>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/hssf/util/CellReference.html#CellReference(java.lang.String)">CellReference</a></strong>(java.lang.String&nbsp;cellRef)</code>
<div class="block">Create an cell ref from a string representation.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colOne"><code><strong><a href="../../../../../org/apache/poi/hssf/util/CellReference.html#CellReference(java.lang.String, int, int, boolean, boolean)">CellReference</a></strong>(java.lang.String&nbsp;pSheetName,
             int&nbsp;pRow,
             int&nbsp;pCol,
             boolean&nbsp;pAbsRow,
             boolean&nbsp;pAbsCol)</code>&nbsp;</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method_summary">
<!--   -->
</a>
<h3>Method Summary</h3>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_org.apache.poi.ss.util.CellReference">
<!--   -->
</a>
<h3>Methods inherited from class&nbsp;org.apache.poi.ss.util.<a href="../../../../../org/apache/poi/ss/util/CellReference.html" title="class in org.apache.poi.ss.util">CellReference</a></h3>
<code><a href="../../../../../org/apache/poi/ss/util/CellReference.html#cellReferenceIsWithinRange(java.lang.String, java.lang.String, org.apache.poi.ss.SpreadsheetVersion)">cellReferenceIsWithinRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#classifyCellReference(java.lang.String, org.apache.poi.ss.SpreadsheetVersion)">classifyCellReference</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#convertColStringToIndex(java.lang.String)">convertColStringToIndex</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#convertNumToColString(int)">convertNumToColString</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#equals(java.lang.Object)">equals</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#formatAsString()">formatAsString</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#getCellRefParts()">getCellRefParts</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#getCol()">getCol</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#getRow()">getRow</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#getSheetName()">getSheetName</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#hashCode()">hashCode</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#isColAbsolute()">isColAbsolute</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#isColumnWithnRange(java.lang.String, org.apache.poi.ss.SpreadsheetVersion)">isColumnWithnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#isPartAbsolute(java.lang.String)">isPartAbsolute</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#isRowAbsolute()">isRowAbsolute</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#isRowWithnRange(java.lang.String, org.apache.poi.ss.SpreadsheetVersion)">isRowWithnRange</a>, <a href="../../../../../org/apache/poi/ss/util/CellReference.html#toString()">toString</a></code></li>
</ul>
<ul class="blockList">
<li class="blockList"><a name="methods_inherited_from_class_java.lang.Object">
<!--   -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
<code>clone, finalize, getClass, notify, notifyAll, wait, wait, wait</code></li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<ul class="blockList">
<li class="blockList"><a name="constructor_detail">
<!--   -->
</a>
<h3>Constructor Detail</h3>
<a name="CellReference(java.lang.String)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CellReference</h4>
<pre>public&nbsp;CellReference(java.lang.String&nbsp;cellRef)</pre>
<div class="block">Create an cell ref from a string representation.  Sheet names containing special characters should be
 delimited and escaped as per normal syntax rules for formulas.</div>
</li>
</ul>
<a name="CellReference(int, int)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CellReference</h4>
<pre>public&nbsp;CellReference(int&nbsp;pRow,
             int&nbsp;pCol)</pre>
</li>
</ul>
<a name="CellReference(int, int, boolean, boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CellReference</h4>
<pre>public&nbsp;CellReference(int&nbsp;pRow,
             int&nbsp;pCol,
             boolean&nbsp;pAbsRow,
             boolean&nbsp;pAbsCol)</pre>
</li>
</ul>
<a name="CellReference(java.lang.String, int, int, boolean, boolean)">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>CellReference</h4>
<pre>public&nbsp;CellReference(java.lang.String&nbsp;pSheetName,
             int&nbsp;pRow,
             int&nbsp;pCol,
             boolean&nbsp;pAbsRow,
             boolean&nbsp;pAbsCol)</pre>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
<!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/CellReference.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/hssf/util/CellRangeAddressList.html" title="class in org.apache.poi.hssf.util"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/hssf/util/HSSFCellUtil.html" title="class in org.apache.poi.hssf.util"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/hssf/util/CellReference.html" target="_top">FRAMES</a></li>
<li><a href="CellReference.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_bottom");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li><a href="#nested_classes_inherited_from_class_org.apache.poi.ss.util.CellReference">NESTED</a>&nbsp;|&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_summary">CONSTR</a>&nbsp;|&nbsp;</li>
<li><a href="#methods_inherited_from_class_org.apache.poi.ss.util.CellReference">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li>FIELD&nbsp;|&nbsp;</li>
<li><a href="#constructor_detail">CONSTR</a>&nbsp;|&nbsp;</li>
<li>METHOD</li>
</ul>
</div>
<a name="skip-navbar_bottom">
<!--   -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>
                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            </small></p>
</body>
</html>
